Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerAccountID (PK) | A unique identifier for a customer account. | ID_CTAC | Identity | integer | |
FinancialLedgerAccountID (FK) | The reference for the FinancialLedgeraAccount | ID_ACNT_LDG | Identity | integer | FinancialLedgerAccount(CO_LE_ACNT_FN) |
CustomerAccountName | Short description for the Customer Account. | NM_CTAC | Name | varchar(40) | |
CustomerAccountTypeCode (FK) | Determines what kind of customer account this is. Examples include a trade account, a school account, a not-for-profit, regular customer, etc. LOYALTY - customer loyalty account for tracking points earned/redeemed REBATE -Customer reward account that pays customers based on cumulative net purchases over a deisgnated period of time TRADE - customer business credit account CONSUMER_CHG - customer individual consumer credit extended by retailer INSTALLMENT - credit account set up for one time purchase LAYAWAY - cash time payment account (not credit) RENTAL - customer rental for videos, equipment WORKORDER - account for handling services like installation and set up BACKORDER - account for handling backorder deposit and adjustments. | TY_CTAC | Code | varchar(20) | CustomerAccountType(CO_CT_ACNT_TYP) |
CustomerID (FK) | A unique system assigned identifier for a person or organization that purchases a product or service from the retailer. | ID_CT | Identity | integer | KeyCustomer(PA_KY_CT) |
CustomerAccountEffectiveDate | The date and time this CustomerAccount instance is ready for use by a customer. | DT_EF | EffectiveDateTime | datetime | |
CustomerAccountExpirationDate | The date and time this CustomerAccount instance may no longer be used by a customer | DT_EP | ExpirationDate | date | |
StatusCode | The current status of this CustomerAccount instance. Note that this status is different from CreditStatusCode which designates the availability of credit to a customer using this account. This StatusCode refers to the current state of the entity instance Valid values are A ACTIVE I INACTIVE Note that the account maintenance process has to synchronize CreditStatusCode values and StatusCode values. | CD_STS | Code2Status | char(2) | |
UnpaidBalanceInterestRatePercent | The rate of interest charged by a retailer on the unpaid balance of the CustomerAccount. The way the rate of interest is used in calculating accrued interest due is determined by the retailer. | PE_UNPD_BLNC_INTRST_RT | Percent | decimal(7,4) | |
GracePeriodDayCount | The number of days a Customer Account may carry a debit balance (customer owing the retailer) without incurring an interest charge. Note that it is up to the retailer to determine how grace days are applied - i.e. on a per CustomerAccountTenderLineItem (individual credit purchase) or on a customer account balance forward basis. In the data model this is a place to store the value used for grace period. | TI_GRC_PRD_DY | QuantityDayCount | decimal(3,0) | |